logo

24ToCode 2020 - Rockwell Imachination

Scheduling Optimization and applied Machine Learning

Architecture



Scheduling Optimization


   Upload Your File:         

  
Aug 32020Aug 4Aug 5Aug 6Aug 7Aug 8Aug 9Aug 10Aug 11 Line 1 Line 1 Line 1 Line 1 Line 1 Line 2 Line 2 Line 2 Line 2 Line 2 Line 2 Line 2 Line 2 Line 2 Line 2 Line 2 Line 2 Line 2 Line 2 Line 2 Line 2 Line 2 Line 2 Line 2 Line 2 Line 2 Line 2 Line 2 Line 2 Line 2 Line 2 Line 2 Line 2 Line 2 Line 2 Line 2 Line 2 Line 2 Line 2 Line 2 Line 2 Line 2 Line 2 Line 2 Line 2 Line 2 Line 2 Line 2 Line 2 Line 2 Line 3 Line 3 Line 3 Line 3 Line 3 Line 3 Line 3 Line 3 Line 3 Line 3 Line 3 Line 3 Line 3 Line 3 Line 3 Line 3 Line 3 Line 3 Line 3 Line 3 Line 3 Line 3 Line 3 Line 4 Line 4 Line 4 Line 4 Line 4 Line 4 Line 4 Line 4 Line 4 Line 4 Line 4 Line 4 Line 4 Line 4 Line 4 Line 4 Line 4 Line 4 Line 4 Line 4 Line 4 Line 4 Line 4 Line 4 Line 4 Line 4 Line 4 Line 4 Line 4 Line 4 Line 4 Line 4 Line 4 Line 4 Line 4 Line 4 Line 4 Line 4 Line 4 Line 4 Line 4 Line 4 Line 4 Line 4 Line 4 Line 4 Line 4 Line 4 Line 4 Line 4 Line 4 Line 4 Line 4 Line 4 Line 4 Line 4 Line 4 Line 4 Line 4 Line 4 Line 4 Line 4 Line 4
MotionCommunication3DiscreteAnalogWarmupRedundantCommunication2OtherApex I/OCommunicationProcessor1w1m6mYTD1yallGantt Chart for Table SchAug3-11




Staff Assignment Optimization



Monday_ShiftA Monday_ShiftB Tuesday_ShiftA Tuesday_ShiftB Wednesday_ShiftA Wednesday_ShiftB Thursday_ShiftA Thursday_ShiftB Friday_ShiftC Saturday_ShiftC Sunday_ShiftC Monday_ShiftA Monday_ShiftB Tuesday_ShiftA Tuesday_ShiftB
Employee_1 4 0 4 0 2 2 0 0 4 3 0 4 0 4 0
Employee_2 0 3 1 1 0 0 0 0 3 0 0 0 3 0 0
Employee_3 0 0 3 0 1 2 4 0 0 0 3 0 0 3 4
Employee_4 0 0 1 0 3 0 4 2 3 4 0 2 0 3 3
Employee_5 0 1 1 0 4 0 0 0 0 0 0 4 4 0 0
Employee_6 4 3 2 0 0 0 0 4 0 1 0 3 0 4 1
Employee_7 0 4 4 3 2 0 2 0 2 3 3 3 0 0 4
Employee_8 1 3 2 0 1 4 0 4 0 2 0 3 2 0 2
Employee_9 0 0 4 1 4 3 0 0 0 0 0 0 0 2 0
Employee_10 0 0 1 0 3 0 3 0 4 0 2 0 4 0 3
Employee_11 3 0 2 0 0 2 3 0 0 0 4 4 0 3 0
Employee_12 2 1 4 2 0 0 2 4 2 1 0 0 2 0 3
Employee_13 4 0 1 2 0 4 2 0 0 0 2 0 0 4 0
Employee_14 0 4 3 0 0 0 0 0 0 0 2 0 3 0 4
Employee_15 3 0 3 0 0 4 0 3 0 4 3 0 0 0 2
Employee_16 1 2 1 4 0 3 0 2 2 4 4 0 0 1 0
Employee_17 0 2 1 4 2 0 3 3 3 0 0 2 4 1 1
Employee_18 2 0 4 0 0 0 0 2 0 3 0 2 3 2 0
Employee_19 2 0 4 0 3 3 0 0 4 2 4 0 2 2 2

Data Summary


1.0beta6
Check for updates
Created & maintained by Francois Bertrand
Graphic design by Jean-Francois Hains
DataFrame
NO COMPARISON TARGET
811
ROWS
0
DUPLICATES
485.4 kb
RAM
19
FEATURES
8
CATEGORICAL
5
NUMERICAL
6
TEXT
1
TOTAL_DOWN_TIME_mins
VALUES:
811
(100%)
MISSING:
---
DISTINCT:
436
(54%)
MAX
599
95%
573
Q3
450
MEDIAN
301
AVG
300
Q1
154
5%
38
MIN
5
RANGE
594
IQR
296
STD
172
VAR
29,709
KURT.
-1.20
SKEW
0.015
SUM
243k
2
STATUS
VALUES:
811
(100%)
MISSING:
---
DISTINCT:
3
(0%)
3
DOWNTIME_TYPE
VALUES:
811
(100%)
MISSING:
---
DISTINCT:
11
(1%)
4
CREATION_TIME_U
VALUES:
811
(100%)
MISSING:
---
DISTINCT:
811
(100%)
1
0%
-
-
2020-06-17 14:44:09
1
0%
-
-
2020-07-27 16:44:55
1
0%
-
-
2020-06-01 15:43:44
1
0%
-
-
2020-08-23 08:57:19
1
0%
-
-
2020-06-01 18:09:58
1
0%
-
-
2020-05-06 11:00:40
1
0%
-
-
2020-07-01 05:30:35
804
99%
-
-
(Other)
5
LAST_MODIFIED_TIME_U
VALUES:
811
(100%)
MISSING:
---
DISTINCT:
811
(100%)
1
0%
-
-
2020-06-17 14:44:09
1
0%
-
-
2020-07-30 02:03:32
1
0%
-
-
2020-05-26 11:49:29
1
0%
-
-
2020-05-23 12:57:31
1
0%
-
-
2020-06-17 18:54:31
1
0%
-
-
2020-05-19 18:26:15
1
0%
-
-
2020-06-09 20:24:08
804
99%
-
-
(Other)
6
RESPONDED_TIME_U
VALUES:
428
(53%)
MISSING:
383
(47%)
DISTINCT:
428
(53%)
1
0%
-
-
2020-08-19 11:02:11
1
0%
-
-
2020-06-30 10:07:46
1
0%
-
-
2020-07-14 18:38:44
1
0%
-
-
2020-08-25 08:45:49
1
0%
-
-
2020-08-11 18:34:36
1
0%
-
-
2020-05-05 16:24:29
1
0%
-
-
2020-06-23 03:26:51
421
98%
-
-
(Other)
7
PROBLEM
VALUES:
811
(100%)
MISSING:
---
DISTINCT:
36
(4%)
8
SOLUTION
VALUES:
811
(100%)
MISSING:
---
DISTINCT:
12
(1%)
9
WORK_ORDER
VALUES:
811
(100%)
MISSING:
---
DISTINCT:
468
(58%)
196
24%
-
-
Don't Care
7
1%
-
-
4011495379
6
1%
-
-
4011320533
5
1%
-
-
4011418019
5
1%
-
-
4011421036
5
1%
-
-
4011433635
4
0%
-
-
4011481174
583
72%
-
-
(Other)
10
MACHINE
VALUES:
435
(54%)
MISSING:
376
(46%)
DISTINCT:
95
(12%)
11
COMPONENT_NUM_H
VALUES:
329
(41%)
MISSING:
482
(59%)
DISTINCT:
113
(14%)
MAX
4.3B
95%
4.0B
Q3
3.1B
MEDIAN
2.8B
AVG
2.2B
Q1
0.9B
5%
0.2B
MIN
0.0B
RANGE
4.2B
IQR
2.2B
STD
1.3B
VAR
1622405.7T
KURT.
-1.23
SKEW
-0.330
SUM
739.6B
12
ACTION_COMMENTS
VALUES:
381
(47%)
MISSING:
430
(53%)
DISTINCT:
273
(34%)
18
5%
-
-
RTS
10
3%
-
-
PN-567261 Part was just completed in Electronic Assembly
7
2%
-
-
PN-566085 Part was just completed in Electronic Assembly
7
2%
-
-
PN-337126 Part was just completed in Electronic Assembly
6
2%
-
-
PN-521631 Part was just completed in Electronic Assembly
6
2%
-
-
PN-414097 Part was just completed in Electronic Assembly
5
1%
-
-
PN-505519 Part was just completed in Electronic Assembly
322
85%
-
-
(Other)
13
FINISHED_TIME_U
VALUES:
574
(71%)
MISSING:
237
(29%)
DISTINCT:
427
(53%)
7
1%
-
-
2020-08-26 15:30:17
6
1%
-
-
2020-06-09 17:41:14
5
1%
-
-
2020-07-28 18:46:54
5
1%
-
-
2020-08-03 16:57:13
5
1%
-
-
2020-07-29 06:02:21
4
1%
-
-
2020-08-13 13:38:50
4
1%
-
-
2020-08-19 10:01:14
538
94%
-
-
(Other)
14
SALES_ORDER_ITEM
VALUES:
615
(76%)
MISSING:
196
(24%)
DISTINCT:
3
(0%)
15
PART_NUM_H
VALUES:
615
(76%)
MISSING:
196
(24%)
DISTINCT:
112
(14%)
MAX
4.3B
95%
3.9B
Q3
3.0B
MEDIAN
2.2B
AVG
2.0B
Q1
1.0B
5%
0.0B
MIN
0.0B
RANGE
4.3B
IQR
2.0B
STD
1.2B
VAR
1554885.2T
KURT.
-1.12
SKEW
-0.005
SUM
1.2T
16
MATERIAL_SHORTAGE_QTY
VALUES:
811
(100%)
MISSING:
---
DISTINCT:
49
(6%)
MAX
200
95%
200
Q3
1
AVG
22
MEDIAN
0
Q1
0
5%
0
MIN
0
RANGE
200
IQR
1.00
STD
53.4
VAR
2,854
KURT.
5.39
SKEW
2.57
SUM
17,845
17
RESPONSE_HR
VALUES:
811
(100%)
MISSING:
---
DISTINCT:
377
(46%)
MAX
1,321
95%
104
Q3
15
AVG
22
MEDIAN
0
Q1
0
5%
0
MIN
0
RANGE
1,321
IQR
15.1
STD
74.3
VAR
5,517
KURT.
139
SKEW
9.91
SUM
17,486
18
GROUP_NAME
VALUES:
811
(100%)
MISSING:
---
DISTINCT:
17
(2%)
19
PROD_SCHEDULER_S
VALUES:
615
(76%)
MISSING:
196
(24%)
DISTINCT:
5
(1%)
GROUP_NAME
MISSING:
---
TOP CATEGORIES
FA_ETECH
344
42%
FA_PCA
147
18%
FA_MAT
108
13%
FA_LEAD
91
11%
FA_QUALITY
34
4%
FA_ME
33
4%
PCBA_QUALITY
13
2%
Don't Care
11
1%
FA_SUP
9
1%
FA_PTECH
6
1%
PCBA_MAT
4
0%
PCBA_ME
3
0%
PCBA_PCA
2
0%
PCBA_LEAD
2
0%
PCBA_METECH
2
0%
TWB_EHS
1
0%
FA_FTPC
1
0%
ALL
811
100%
CATEGORICAL ASSOCIATIONS
(UNCERTAINTY COEFFICIENT, 0 to 1)
GROUP_NAME
PROVIDES INFORMATION ON...
DOWNTIME_TYPE
0.65
PROBLEM
0.44
SOLUTION
0.39
MACHINE
0.25
SALES_ORDER_ITEM
0.24
STATUS
0.24
PROD_SCHEDULER_S
0.14

THESE FEATURES GIVE INFORMATION
ON GROUP_NAME:
PROBLEM
0.58
DOWNTIME_TYPE
0.42
MACHINE
0.39
SOLUTION
0.30
PROD_SCHEDULER_S
0.12
STATUS
0.10
SALES_ORDER_ITEM
0.00

NUMERICAL ASSOCIATIONS
(CORRELATION RATIO, 0 to 1)
GROUP_NAME
CORRELATION RATIO WITH...
MATERIAL_SHORTAGE_QTY
0.73
COMPONENT_NUM_H
0.71
PART_NUM_H
0.38
RESPONSE_HR
0.28
TOTAL_DOWN_TIME_mins
0.14